The General tab allows you to set login properties which are:
Login Name
Set name of the login.
Authentication Type
Select the authentication type.
Windows Authentication
Selects to use the Windows login for authentication.SQL Server Authentication
Selects to use the SQL Server login for authentication.Password
A login must specify password to log on to the database.Confirm Password
Re-type the login's password here.
Enforce Password Policy
In SQL Server 2005 or above, you can check this option to force password to follow password policy of SQL Server.
Enforce Password Expiration
In SQL Server 2005 or above, you can check this option to force password to have expiry date.
User Must Change Password at Next Login
In SQL Server 2005 or above, you can check this option to force user to change password everytime when login.Mapped to Certificate
In SQL Server 2005 or above, you can select to use certificate for authentication.SQL Server contains features that enable you to create and manage certificates and keys for use with the server and database. You can use externally generated certificates or SQL Server can generate certificates.
Certificate Name
Select the certificate name.Mapped to Asymmetric Key
In SQL Server 2005 or above, you can select to use asymmetric key for authentication.Asymmetric Key Name
Selects the asymmetric key name.Note: Certificates and asymmetric keys are both ways to use asymmetric encryption. There is no difference between the two mechanisms for the cryptographic algorithm, and no difference in strength given the same key length.
Default Database
Selects the default database when login.
Default Language
Selects the default display language when login.
Credential
In SQL Server 2005 or above, you can add credential on specific role for this login.
A credential is a record that contains the authentication information (credentials) required to connect to a resource outside SQL Server. This information is used internally by SQL Server.
Enabled
In SQL Server 2005 or above, you can check this option to enable the login.